package com.mayuhao.professionmanage.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.mayuhao.professionmanage.entity.CssDepVO;
import com.mayuhao.professionmanage.entity.CssProfession;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author 马宇豪
 * @since 2022-10-24
 */
public interface CssProfessionMapper extends BaseMapper<CssProfession> {

    @Select(" SELECT css_department.department_id,css_department.department_name FROM css_department")
    List<CssDepVO> findDep();
//    List<String> findDep();

    Page<CssDepVO> page(Page page,
                        @Param("searchId") String id,
                        @Param("searchName") String name);

}
